package com.msh.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.msh.entity.OrderCollectEntity;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.time.LocalDateTime;

@Mapper
public interface OrderCollectDao extends BaseMapper<OrderCollectEntity>{
    @Select("select IFNULL(SUM(total_bill),0) from tb_order_collect where date between #{start} and #{end}")
    Long getTotalBill(LocalDateTime start,LocalDateTime end);
}
